Managing Multiple Isolation Levels in Middleware Database Replication Protocols

نویسندگان

  • Josep M. Bernabé-Gisbert
  • Raúl Salinas-Monteagudo
  • Luis Irún-Briz
  • Francesc D. Muñoz-Escoí
چکیده

Many database replication protocols have been designed for guaranteeing a serialisable isolation level, since it is appropriate for almost all applications. However, it also requires a tight coordination among replicas and might generate high abortion rates with some workloads. So, other isolation levels have also been considered, such as snapshot isolation and cursor stability, but none of the previous works has proposed an overall support for more than one isolation level at the same time. This paper explores such a research line.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

A Middleware Database Replication Protocol Providing Different Isolation Levels

Database replication protocols have been usually designed in order to support a single isolation level. This paper proposes a middleware protocol able to manage three different isolation levels over multi-version DBMSs: GSI, SI, and serializable. This ensures a better support for applications that demand different isolation levels for their transactions. Additionally, this protocol is also able...

متن کامل

A Weak Voting Database Replication Protocol Providing Different Isolation Levels

Database replication protocols have been usually designed in order to support a single isolation level. This paper proposes a middleware replication protocol able to manage three different isolation levels over multi-version DBMSs that provides SI level: GSI, SI, and serializable. This ensures a better support for applications that demand different isolation levels for their transactions. Addit...

متن کامل

Pangea: An Eager Database Replication Middleware guaranteeing Snapshot Isolation without Modification of Database Servers

Recently, several middleware-based approaches have been proposed. If we implement all functionalities of database replication only in a middleware layer, we can avoid the high cost of modifying existing database servers or scratchbuilding. However, it is a big challenge to propose middleware which can enhance performance and scalability without modification of database servers because the restr...

متن کامل

Weak Voting Database Replication Protocols Providing Different Isolation Levels

Recently, several works have taken advantage of a database isolation notion suitable for replicated approaches, called Generalized Snapshot Isolation, that provides greater performance since read-only transactions are never blocked nor cause update transactions to block or abort. However, this concept has not been formally described for replicated environments where a logical copy of the system...

متن کامل

Extending Middleware Protocols for Database Replication with Integrity Support

Current middleware database replication protocols take care of read-write conflict evaluation. If there are no such conflicts, protocols sanction transactions to commit. Other conflicts may arise due to integrity violation. So, if, in addition to the consistency of transactions and replicas, also the consistency of integrity constraints is to be supported, some more care must be taken. Some cla...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2006